Example of Using PostgreSQL Console

Basic PostgreSQL query statements

report_sample=# select datname from pg_database;
+---------------+
| datname       |
+---------------+
| template1     |
| template0     |
| postgres      |
| report_sample |
| report_backup |
+---------------+
5 rows in set (0.01 sec)

report_sample=# select tablename from pg_tables;
+-------------------------+
| tablename               |
+-------------------------+
| customer                |
| clients                 |
| items                   |
| orders                  |
| parts                   |
| plbiolife               |
+-------------------------+
6 rows in set (0.02 sec)

report_sample=# select "Description", "Cost" from public.parts where "PartNo" = 2619;
+--------------------+-------+
| Description        | Cost  |
+--------------------+-------+
| Navigation Compass | 9.177 |
+--------------------+-------+
1 row in set (0.03 sec)

report_sample=#